package com.zlf.sb.demo;

/***
 *@title ClientTest
 *@description <TODO description class purpose>
 *@author wgc_j
 *@version 1.0.0
 *@create 2025-02-19 9:50
 **/
public class ClientTest {
    public static void main(String[] args) throws CloneNotSupportedException {
         String ss= "select count(aa.endor_no) from "+
                 "(select a.endor_no,a.kind_sn,a.kind_code,sum(a.suminsured_amount) suminsured_amount "+
                 "from udm_p_thirdpremium_archive a where a.timestamp>sysdate-2/24  group by a.endor_no,a.kind_sn,a.kind_code) aa,udm_policy_coverage bb "+
                 "where aa.endor_no = bb.endor_no and nvl(aa.kind_sn,1) = nvl(bb.kind_sn,1) and aa.kind_code = bb.kind_code "+
                 "and aa.suminsured_amount!=bb.suminsured_amount ";
         System.out.println(ss);
    }
}
